package com.shangyueshang.response;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.shangyueshang.converter.YearMonthConverter;
import lombok.Data;

import java.math.BigDecimal;
import java.time.YearMonth;

/**
 * @author JokeyFeng
 * @date: 2023/8/5 16:43
 * @project: shangyueshang
 * @package: com.shangyueshang.response
 * @comment:
 */
@Data
public class GoodsRevenueExportDTO {
	
	@ColumnWidth(20)
	@ExcelProperty(value = "店铺")
	private String shop;
	
	@ColumnWidth(20)
	@ExcelProperty(value = "SKU")
	private String sku;
	
	@ColumnWidth(20)
	@ExcelProperty(value = "月份", converter = YearMonthConverter.class)
	private YearMonth tradeMonth;
	
	@ColumnWidth(20)
	@ExcelProperty(value = "销售总额(￥)")
	private BigDecimal productSales;
	
	@ColumnWidth(20)
	@ExcelProperty(value = "销量")
	private Integer saleQuantity;
	
	@ColumnWidth(20)
	@ExcelProperty(value = "毛收入(￥)")
	private BigDecimal saleRevenue;
	
	@ColumnWidth(20)
	@ExcelProperty(value = "平台佣金(￥)")
	private BigDecimal sellingFee;
	
	@ColumnWidth(20)
	@ExcelProperty(value = "平台配送费(￥)")
	private BigDecimal fbaFee;
	
	@ColumnWidth(20)
	@ExcelProperty(value = "预估头程(￥)")
	private BigDecimal headwayFee;
	
	@ColumnWidth(20)
	@ExcelProperty(value = "采购成本(￥)")
	private BigDecimal purchaseFee;
	
	@ColumnWidth(20)
	@ExcelProperty(value = "包装成本(￥)")
	private BigDecimal packFee;
	
	@ColumnWidth(20)
	@ExcelProperty(value = "退货退款(￥)")
	private BigDecimal returnFee;
	
	@ColumnWidth(20)
	@ExcelProperty(value = "退货退款数量")
	private Integer returnQuantity;
	
	@ColumnWidth(20)
	@ExcelProperty(value = "退货率")
	private String returnRatio;
	
	@ColumnWidth(20)
	@ExcelProperty(value = "FBA配送占比")
	private String fbaProportion;
	
	@ColumnWidth(20)
	@ExcelProperty(value = "毛利润(￥)")
	private BigDecimal netProfit;
	
	@ColumnWidth(20)
	@ExcelProperty(value = "广告费(￥)")
	private BigDecimal advertiseFee;
	
	@ColumnWidth(20)
	@ExcelProperty(value = "广告占比(￥)")
	private String advertiseRatio;
	
	@ColumnWidth(20)
	@ExcelProperty(value = "仓储费(￥)")
	private BigDecimal storageFee;
}
